490

LOST IN SPACE Doufu? Hmm, looks like that page doesn't exist.

Go Home

(psycopg2.DataError) invalid input syntax for integer: "'+MarketingPlansArray[$id].MarketingPlanId+'" LINE 3: ...duct"."CompanyId" = 8 AND "Product"."ProductId" = '''+Market... ^ [SQL: 'SELECT "Product"."ProductId" AS "Product_ProductId" \nFROM "Product" \nWHERE "Product"."CompanyId" = %(CompanyId_1)s AND "Product"."ProductId" = %(ProductId_1)s AND "Product"."Status" NOT IN (%(Status_1)s, %(Status_2)s) AND "Product"."StartDate" <= %(StartDate_1)s AND "Product"."EndDate" >= %(EndDate_1)s \n LIMIT %(param_1)s'] [parameters: {'CompanyId_1': 8, 'StartDate_1': datetime.datetime(2024, 5, 15, 3, 3, 7, 916794), 'EndDate_1': datetime.datetime(2024, 5, 15, 3, 3, 7, 916794), 'ProductId_1': "'+MarketingPlansArray[$id].MarketingPlanId+'", 'Status_1': 0, 'param_1': 1, 'Status_2': 9}] (Background on this error at: http://sqlalche.me/e/9h9h)